the implement method of distributed database's synchronous updating 分布式數據庫同步更新的實現方法
in the near future, expect to see the addition of an option for synchronous updates of specific directory trees, which is a feature that will be of use primarily to mailer programs 很快,我們有望看到添加一個選項用于特定目錄樹的同步更新,這個功能將主要用于郵件程序。
at the same time there is much data interchange among these systems, much common data is saved repeatedly, some data is even the same, it is very important to keep the redundance data in consistent and synchronous update the common data in this information network 同時系統(tǒng)間需要進行大量的數據交換,許多公共數據重復存放,部分數據甚至完全相同,在這個信息網中保持三個子網中的冗余數據的一致性和公共數據的同步更新非常重要。
this paper provides a discussion on the theory of distributed database, summarize the virtues and flaws of two-phase-commit protocol and replication technology, and then puts forward a synchronous update system model to solve the problems encountered while longkou port was realizing the data share among different kind of databases located in different area . this model, based on 2pc and the mainstream database replicate technology at present, can realize data sharing and data consistency among heterogeneous databases by odbc and tcp / ip technology, and now has been partly implemented 本文在討論有關分布式數據庫理論的基礎上,總結了兩階段提交協(xié)議和數據庫復制技術在異構型分布式數據同步中的優(yōu)缺點,以龍口港信息系統(tǒng)在實現異構分布式數據庫共享過程中遇到的問題為背景,利過odbc和tcpip技術,對數據庫更新事務進行存儲轉發(fā),進而實現數據同步更新的系統(tǒng)模型,提出了一套網絡環(huán)境下的分布式數據庫同步機制。